IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spm_GetSetting')
	BEGIN
		DROP  Procedure  spm_GetSetting
	END

GO

CREATE Procedure spm_GetSetting
(
@Name varchar(100)
)
AS
	SELECT [Value] FROM GlobalSettings WHERE [name]=@Name
	RETURN 0
GO
 